|
400
|
Can I change the format of date to be shown in the control
public void init()
{
COM com_Column,com_Column1,com_Column2,com_Columns,com_Items;
anytype var_Column,var_Column1,var_Column2,var_Columns,var_Items;
str var_s;
;
super();
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
com_Columns.Add("Default");
var_Column = COM::createFromVariant(com_Columns.Add("Format.1")); com_Column = var_Column;
com_Column.ComputedField("%0");
com_Column.FormatColumn("dateF(value) replace `/` with `-`");
var_Column1 = COM::createFromVariant(com_Columns.Add("Format.2")); com_Column1 = var_Column1;
com_Column1.ComputedField("%0");
com_Column1.Def(17/*exCaptionFormat*/,COMVariant::createFromInt(1));
com_Column1.FormatColumn("`<b>`+ shortdate(value) + `</b> ` + timeF(value)");
var_Column2 = COM::createFromVariant(com_Columns.Add("Format.3")); com_Column2 = var_Column2;
com_Column2.ComputedField("%0");
com_Column2.Def(17/*exCaptionFormat*/,COMVariant::createFromInt(1));
var_s = "( dateF(value) replace `/` with `-` ) + ` <b>`+ ( weekday(value) case ( 0 : `Su`; 1 : `Mo`; 2 : `Tu`; 3 : `We`; 4 : `Th`; 5 : `F";
var_s = var_s + "r`; 6 : `Sa`) )";
com_Column2.FormatColumn(var_s);
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("1/1/2001 10:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("1/2/2001 10:00:00",213)));
}
|
|
399
|
How can I put a picture on the cell's background (method 3)
public void init()
{
COM com_Column,com_Columns,com_Items;
anytype var_Column,var_Columns,var_Items;
int i;
;
super();
exlist1.VisualAppearance().Add(1,"c:\\exontrol\\images\\normal.ebn");
exlist1.VisualAppearance().Add(2,"CP:1 0 0 -164 0");
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
com_Columns.Add("column");
var_Column = COM::createFromVariant(com_Columns.Add("column")); com_Column = var_Column;
com_Column.Alignment(1/*CenterAlignment*/);
com_Column.HeaderAlignment(1/*CenterAlignment*/);
var_Items = exlist1.Items(); com_Items = var_Items;
i = com_Items.Add();
com_Items.SelectableItem(i,false);
com_Items.Caption(i,COMVariant::createFromInt(1),"caption");
com_Items.CellBackColor(i,COMVariant::createFromInt(1),0x2000000);
}
|
|
398
|
How can I put a picture on the cell's background (method 2)
public void init()
{
COM com_Columns,com_Items;
anytype var_Columns,var_Items;
int i;
;
super();
exlist1.VisualAppearance().Add(1,"c:\\exontrol\\images\\normal.ebn");
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
com_Columns.Add("column");
com_Columns.Add("column");
var_Items = exlist1.Items(); com_Items = var_Items;
i = com_Items.Add();
com_Items.SelectableItem(i,false);
com_Items.Caption(i,COMVariant::createFromInt(1),"caption");
com_Items.CellBackColor(i,COMVariant::createFromInt(1),0x1000000);
com_Items.CellPicture(i,COMVariant::createFromInt(1),COM::createFromVariant(exlist1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\auction.gif`)")));
com_Items.CellPictureWidth(i,COMVariant::createFromInt(1),128);
com_Items.CellPictureHeight(i,COMVariant::createFromInt(1),exlist1.DefaultItemHeight());
}
|
|
397
|
How can I put a picture on the cell's background (method 1)
public void init()
{
COM com_Column,com_Columns,com_Items;
anytype var_Column,var_Columns,var_Items;
int i;
;
super();
exlist1.VisualAppearance().Add(1,"c:\\exontrol\\images\\normal.ebn");
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
com_Columns.Add("column");
var_Column = COM::createFromVariant(com_Columns.Add("column")); com_Column = var_Column;
com_Column.Alignment(1/*CenterAlignment*/);
com_Column.HeaderAlignment(1/*CenterAlignment*/);
var_Items = exlist1.Items(); com_Items = var_Items;
i = com_Items.Add();
com_Items.SelectableItem(i,false);
com_Items.Caption(i,COMVariant::createFromInt(1),"caption");
com_Items.CellBackColor(i,COMVariant::createFromInt(1),0x1000000);
}
|
|
396
|
How do I access the cells, or how do I get the values in the columns
public void init()
{
COM com_Columns,com_Items;
anytype var_Columns,var_Items;
int h;
;
super();
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
com_Columns.Add("C1");
com_Columns.Add("C2");
com_Columns.Add("C3");
var_Items = exlist1.Items(); com_Items = var_Items;
h = com_Items.Add("Item 1");
com_Items.Caption(h,COMVariant::createFromInt(1),"SubItem 1.1");
com_Items.Caption(h,COMVariant::createFromInt(2),"SubItem 1.2");
print( com_Items.Caption(h,COMVariant::createFromInt(2)) );
}
|
|
395
|
How can I apply the same ConditionalFormat on more than 1(one) column (multiple columns and not on item)
public void init()
{
COM com_Columns,com_ConditionalFormat,com_ConditionalFormat1,com_Items;
anytype var_Columns,var_ConditionalFormat,var_ConditionalFormat1,var_Items;
;
super();
exlist1.BeginUpdate();
var_ConditionalFormat = COM::createFromObject(exlist1.ConditionalFormats()).Add("1","K1"); com_ConditionalFormat = var_ConditionalFormat;
com_ConditionalFormat.BackColor(WinApi::RGB2int(255,0,0));
com_ConditionalFormat.ApplyTo(1);
var_ConditionalFormat1 = COM::createFromObject(exlist1.ConditionalFormats()).Add("1","K2"); com_ConditionalFormat1 = var_ConditionalFormat1;
com_ConditionalFormat1.BackColor(WinApi::RGB2int(255,0,0));
com_ConditionalFormat1.ApplyTo(2);
exlist1.MarkSearchColumn(false);
exlist1.DrawGridLines(-2/*0xfffffffe | exVLines*/);
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
com_Columns.Add("Column 1");
com_Columns.Add("Column 2");
com_Columns.Add("Column 3");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add();
com_Items.Add();
com_Items.Add();
exlist1.EndUpdate();
}
|
|
394
|
How can I get the list of items as they are displayed
public void init()
{
COM com_Column,com_Items;
anytype var_Column,var_Items;
;
super();
exlist1.BeginUpdate();
exlist1.BackColorAlternate(WinApi::RGB2int(240,240,240));
exlist1.Columns().Add("Names");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add("Mantel");
com_Items.Add("Mechanik");
com_Items.Add("Motor");
com_Items.Add("Murks");
com_Items.Add("Märchen");
com_Items.Add("Möhren");
com_Items.Add("Mühle");
var_Column = COM::createFromObject(exlist1.Columns()).Item(COMVariant::createFromInt(0)); com_Column = var_Column;
com_Column.SortOrder(1/*SortAscending*/);
exlist1.EndUpdate();
print( exlist1.GetItems(COMVariant::createFromInt(1)) );
}
|
|
393
|
Is posible to reduce the size of the picture to be shown in the column's caption
public void init()
{
;
super();
exlist1.BeginUpdate();
exlist1.HTMLPicture("pic1","c:\\exontrol\\images\\zipdisk.gif");
exlist1.HeaderHeight(48);
COM::createFromVariant(exlist1.Columns().Add("DefaultSize")).HTMLCaption("Default-Size <img>pic1</img> Picture");
COM::createFromVariant(exlist1.Columns().Add("CustomSize")).HTMLCaption("Custom-Size <img>pic1:16</img> Picture");
exlist1.EndUpdate();
}
|
|
392
|
How can I change the color, font, bold etc for the items/cells in the same column or for the entire column
public void init()
{
COM com_Column,com_ConditionalFormat,com_Items;
anytype var_Column,var_ConditionalFormat,var_Items;
;
super();
exlist1.BeginUpdate();
exlist1.MarkSearchColumn(false);
var_ConditionalFormat = COM::createFromObject(exlist1.ConditionalFormats()).Add("1"); com_ConditionalFormat = var_ConditionalFormat;
com_ConditionalFormat.Bold(true);
com_ConditionalFormat.ForeColor(WinApi::RGB2int(255,0,0));
com_ConditionalFormat.ApplyTo(1);
exlist1.Columns().Add("C1");
var_Column = COM::createFromVariant(exlist1.Columns().Add("C2")); com_Column = var_Column;
com_Column.HeaderBold(true);
com_Column.HTMLCaption("<fgcolor=FF0000>C2");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Caption(com_Items.Add(COMVariant::createFromInt(10)),COMVariant::createFromInt(1),COMVariant::createFromInt(11));
com_Items.Caption(com_Items.Add(COMVariant::createFromInt(12)),COMVariant::createFromInt(1),COMVariant::createFromInt(13));
exlist1.EndUpdate();
}
|
|
391
|
Is it possible to limit the height of item while resizing the row
// AddItem event - Occurs after a new Item is inserted to Items collection.
void onEvent_AddItem(int _Item)
{
;
exlist1.Items().ItemMinHeight(_Item,18);
exlist1.Items().ItemMaxHeight(_Item,72);
}
public void init()
{
COM com_Column,com_Items;
anytype var_Column,var_Items;
;
super();
exlist1.BeginUpdate();
exlist1.ItemsAllowSizing(-1/*exResizeItem*/);
exlist1.ScrollBySingleLine(false);
exlist1.BackColorAlternate(WinApi::RGB2int(240,240,240));
exlist1.Columns().Add("Names");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add("Mantel");
com_Items.Add("Mechanik");
com_Items.Add("Motor");
com_Items.Add("Murks");
com_Items.Add("Märchen");
com_Items.Add("Möhren");
com_Items.Add("Mühle");
var_Column = COM::createFromObject(exlist1.Columns()).Item(COMVariant::createFromInt(0)); com_Column = var_Column;
com_Column.SortOrder(1/*SortAscending*/);
exlist1.EndUpdate();
}
|
|
390
|
Can I specify un-sortable items so they keep their position once the user sorts the columns
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
COM::createFromVariant(exlist1.Columns().Add("Def")).SortType(1/*SortNumeric*/);
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.SortableItem(com_Items.Add("Unsortable"),false);
com_Items.Add(COMVariant::createFromInt(1));
com_Items.Add(COMVariant::createFromInt(2));
com_Items.Add(COMVariant::createFromInt(3));
}
|
|
389
|
The item is not getting selected when clicking the cell's checkbox. What should I do
// CellStateChanged event - Fired after cell's state is changed.
void onEvent_CellStateChanged(int _ItemIndex,int _ColIndex)
{
;
exlist1.Items().SelectItem(_ItemIndex,true);
}
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
COM::createFromVariant(exlist1.Columns().Add("Check")).Def(0/*exCellHasCheckBox*/,COMVariant::createFromBoolean(true));
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add(COMVariant::createFromInt(0));
com_Items.Add(COMVariant::createFromInt(1));
com_Items.Add(COMVariant::createFromInt(2));
com_Items.Add(COMVariant::createFromInt(3));
}
|
|
388
|
Does your control supports multiple lines tooltip
public void init()
{
str var_s;
;
super();
exlist1.HTMLPicture("pic1","c:\\exontrol\\images\\zipdisk.gif");
exlist1.ToolTipDelay(1);
var_s = "<br><font Tahoma;10>This</font> is a <b>multi-lines</b> tooltip assigned to a column. The tooltip supports built-in HTML tags, i";
var_s = var_s + "cons and pictures.<br><br><br><img>pic1</img> picture ... <br><br>";
COM::createFromVariant(exlist1.Columns().Add("tootip")).ToolTip(var_s);
}
|
|
387
|
How can I prevent highlighting the column from the cursor - point
public void init()
{
str var_s;
;
super();
var_s = "gBFLBCJwBAEHhEJAEGg4BI0IQAAYAQGKIYBkAKBQAGaAoDDUOQzQwAAxDKKUEwsACEIrjKCYVgOHYYRrIMYgBCMJhLEoaZLhEZRQiqDYtRDFQBSDDcPw/EaRZohGaYJg";
var_s = var_s + "EgI=";
exlist1.VisualAppearance().Add(1,COMVariant::createFromStr(var_s));
exlist1.Background(32/*exCursorHoverColumn*/,0x1000000);
COM::createFromVariant(exlist1.Columns().Add("S")).Width(32);
COM::createFromVariant(exlist1.Columns().Add("Level 1")).LevelKey(COMVariant::createFromInt(1));
COM::createFromVariant(exlist1.Columns().Add("Level 2")).LevelKey(COMVariant::createFromInt(1));
COM::createFromVariant(exlist1.Columns().Add("Level 3")).LevelKey(COMVariant::createFromInt(1));
COM::createFromVariant(exlist1.Columns().Add("E1")).Width(32);
COM::createFromVariant(exlist1.Columns().Add("E2")).Width(32);
COM::createFromVariant(exlist1.Columns().Add("E3")).Width(32);
COM::createFromVariant(exlist1.Columns().Add("E4")).Width(32);
}
|
|
386
|
Is there any option to show the tooltip programmatically
// MouseMove event - Occurs when the user moves the mouse.
void onEvent_MouseMove(int _Button,int _Shift,int _X,int _Y)
{
;
exlist1.ShowToolTip(exlist1.ItemFromPoint(-1,-1,c,hit),"","8","8");
}
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.BeginUpdate();
exlist1.Columns().Add("Def");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add("Item 1");
com_Items.Add("Item 2");
com_Items.Add("Item 3");
exlist1.EndUpdate();
}
|
|
385
|
Is it possible to prevent covering the colors by selected rows
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.SelBackMode(1/*exTransparent*/);
exlist1.BackColorAlternate(WinApi::RGB2int(240,240,240));
exlist1.Columns().Add("Column");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add("Item 1");
com_Items.Add("Item 2");
com_Items.Add("Item 3");
com_Items.Add("Item 4");
com_Items.Add("Item 5");
}
|
|
384
|
Can I use PNG images to display pictures in the control
public void init()
{
;
super();
exlist1.HTMLPicture("pic1","c:\\exontrol\\images\\card.png");
exlist1.HeaderHeight(48);
COM::createFromVariant(exlist1.Columns().Add("ColumnName")).HTMLCaption("<b>HTML</b> Column <img>pic1</img> Picture");
}
|
|
383
|
Does your control support conditional format and computed fields
public void init()
{
COM com_Column,com_Column1,com_Column2,com_Column3,com_Columns,com_ConditionalFormat,com_ConditionalFormat1,com_ConditionalFormat2,com_ConditionalFormats,com_Items;
anytype var_Column,var_Column1,var_Column2,var_Column3,var_Columns,var_ConditionalFormat,var_ConditionalFormat1,var_ConditionalFormat2,var_ConditionalFormats,var_Items;
int h1;
;
super();
exlist1.BeginUpdate();
exlist1.MarkSearchColumn(false);
var_ConditionalFormats = exlist1.ConditionalFormats(); com_ConditionalFormats = var_ConditionalFormats;
var_ConditionalFormat = com_ConditionalFormats.Add("%1 >4"); com_ConditionalFormat = var_ConditionalFormat;
com_ConditionalFormat.Bold(true);
com_ConditionalFormat.StrikeOut(true);
com_ConditionalFormat.ForeColor(WinApi::RGB2int(255,0,0));
com_ConditionalFormat.ApplyTo(1);
var_ConditionalFormat1 = com_ConditionalFormats.Add("%2 > 4"); com_ConditionalFormat1 = var_ConditionalFormat1;
com_ConditionalFormat1.Bold(true);
com_ConditionalFormat1.StrikeOut(true);
com_ConditionalFormat1.ForeColor(WinApi::RGB2int(255,0,0));
com_ConditionalFormat1.ApplyTo(2);
var_ConditionalFormat2 = com_ConditionalFormats.Add("%3 > 4"); com_ConditionalFormat2 = var_ConditionalFormat2;
com_ConditionalFormat2.Bold(true);
com_ConditionalFormat2.StrikeOut(true);
com_ConditionalFormat2.ForeColor(WinApi::RGB2int(255,0,0));
com_ConditionalFormat2.ApplyTo(3);
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
com_Columns.Add("Name");
var_Column = COM::createFromVariant(com_Columns.Add("A")); com_Column = var_Column;
com_Column.SortType(1/*SortNumeric*/);
com_Column.AllowSizing(false);
com_Column.Width(36);
com_Column.FormatColumn("len(value) ? value + ' +'");
var_Column1 = COM::createFromVariant(com_Columns.Add("B")); com_Column1 = var_Column1;
com_Column1.SortType(1/*SortNumeric*/);
com_Column1.AllowSizing(false);
com_Column1.Width(36);
com_Column1.FormatColumn("len(value) ? value + ' +'");
var_Column2 = COM::createFromVariant(com_Columns.Add("C")); com_Column2 = var_Column2;
com_Column2.SortType(1/*SortNumeric*/);
com_Column2.AllowSizing(false);
com_Column2.Width(36);
com_Column2.FormatColumn("len(value) ? value + ' ='");
var_Column3 = COM::createFromVariant(com_Columns.Add("A+B+C")); com_Column3 = var_Column3;
com_Column3.SortType(1/*SortNumeric*/);
com_Column3.AllowSizing(false);
com_Column3.Width(64);
com_Column3.ComputedField("%1+%2+%3");
com_Column3.FormatColumn("((0:=dbl(value)) < 10? '<fgcolor=808080><font ;7>' :'<b>') + currency(=:0)");
com_Column3.Def(17/*exCaptionFormat*/,COMVariant::createFromInt(1));
var_Items = exlist1.Items(); com_Items = var_Items;
h1 = com_Items.Add("Item 1");
com_Items.Caption(h1,COMVariant::createFromInt(1),COMVariant::createFromInt(7));
com_Items.Caption(h1,COMVariant::createFromInt(2),COMVariant::createFromInt(3));
com_Items.Caption(h1,COMVariant::createFromInt(3),COMVariant::createFromInt(1));
h1 = com_Items.Add("Item 2");
com_Items.Caption(h1,COMVariant::createFromInt(1),COMVariant::createFromInt(2));
com_Items.Caption(h1,COMVariant::createFromInt(2),COMVariant::createFromInt(5));
com_Items.Caption(h1,COMVariant::createFromInt(3),COMVariant::createFromInt(12));
h1 = com_Items.Add("Item 3");
com_Items.Caption(h1,COMVariant::createFromInt(1),COMVariant::createFromInt(2));
com_Items.Caption(h1,COMVariant::createFromInt(2),COMVariant::createFromInt(2));
com_Items.Caption(h1,COMVariant::createFromInt(3),COMVariant::createFromInt(4));
h1 = com_Items.Add("Item 4");
com_Items.Caption(h1,COMVariant::createFromInt(1),COMVariant::createFromInt(2));
com_Items.Caption(h1,COMVariant::createFromInt(2),COMVariant::createFromInt(9));
com_Items.Caption(h1,COMVariant::createFromInt(3),COMVariant::createFromInt(4));
exlist1.EndUpdate();
}
|
|
382
|
Is there any way to display the vertical scroll bar on the left side, as I want to align my data to the right
public void init()
{
COM com_Columns;
anytype var_Columns;
;
super();
exlist1.BeginUpdate();
exlist1.ScrollBars(15/*DisableBoth*/);
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
com_Columns.Add("C1");
com_Columns.Add("C2");
com_Columns.Add("C3");
com_Columns.Add("C4");
com_Columns.Add("C5");
com_Columns.Add("C6");
com_Columns.Add("C7");
com_Columns.Add("C8");
exlist1.RightToLeft(true);
exlist1.EndUpdate();
}
|
|
381
|
Can I display the cell's check box after the text
public void init()
{
COM com_Column,com_Items;
anytype var_Column,var_Items;
;
super();
var_Column = COM::createFromVariant(exlist1.Columns().Add("Column")); com_Column = var_Column;
com_Column.Def(0/*exCellHasCheckBox*/,COMVariant::createFromBoolean(true));
com_Column.Def(34/*exCellDrawPartsOrder*/,"caption,check");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.CellHasCheckBox(com_Items.Add("Caption 1"),COMVariant::createFromInt(0),true);
com_Items.CellHasCheckBox(com_Items.Add("Caption 2"),COMVariant::createFromInt(0),true);
}
|
|
380
|
Can I change the order of the parts in the cell, as checkbox after the text, and so on
public void init()
{
COM com_Items;
anytype var_Items;
int h;
str var_s;
;
super();
var_s = "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql";
var_s = var_s + "Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0";
var_s = var_s + "ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN";
var_s = var_s + "AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=";
exlist1.Images(COMVariant::createFromStr(var_s));
COM::createFromVariant(exlist1.Columns().Add("Column")).Def(34/*exCellDrawPartsOrder*/,"caption,check,icon,icons,picture");
var_Items = exlist1.Items(); com_Items = var_Items;
h = com_Items.Add("Text");
com_Items.CellImage(h,COMVariant::createFromInt(0),1);
com_Items.CellHasCheckBox(h,COMVariant::createFromInt(0),true);
}
|
|
379
|
Can I have an image displayed after the text. Can I get that effect without using HTML content
public void init()
{
COM com_Items;
anytype var_Items;
int h;
str var_s;
;
super();
var_s = "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql";
var_s = var_s + "Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0";
var_s = var_s + "ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN";
var_s = var_s + "AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=";
exlist1.Images(COMVariant::createFromStr(var_s));
COM::createFromVariant(exlist1.Columns().Add("Column")).Def(34/*exCellDrawPartsOrder*/,"caption,icon,check,icons,picture");
var_Items = exlist1.Items(); com_Items = var_Items;
h = com_Items.Add("Text");
com_Items.CellImage(h,COMVariant::createFromInt(0),1);
}
|
|
378
|
Is there any way to display the vertical scroll bar on the left side, as I want to align my data to the right
public void init()
{
COM com_Columns;
anytype var_Columns;
;
super();
exlist1.BeginUpdate();
exlist1.ScrollBars(15/*DisableBoth*/);
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
com_Columns.Add("C1");
com_Columns.Add("C2");
com_Columns.Add("C3");
com_Columns.Add("C4");
com_Columns.Add("C5");
com_Columns.Add("C6");
com_Columns.Add("C7");
com_Columns.Add("C8");
exlist1.RightToLeft(true);
exlist1.EndUpdate();
}
|
|
377
|
How can I change the foreground color for a particular column
public void init()
{
COM com_Columns;
anytype var_Columns;
;
super();
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
com_Columns.Add("Column 1");
COM::createFromVariant(com_Columns.Add("Column 2")).Def(8/*exHeaderForeColor*/,COMVariant::createFromInt(8439039));
com_Columns.Add("Column 3");
}
|
|
376
|
How can I change the background color for a particular column
public void init()
{
COM com_Columns;
anytype var_Columns;
;
super();
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
com_Columns.Add("Column 1");
COM::createFromVariant(com_Columns.Add("Column 2")).Def(7/*exHeaderBackColor*/,COMVariant::createFromInt(8439039));
com_Columns.Add("Column 3");
}
|
|
375
|
How can I display the column using currency format and enlarge the font for certain values
public void init()
{
COM com_Column,com_Items;
anytype var_Column,var_Items;
;
super();
var_Column = COM::createFromVariant(exlist1.Columns().Add("Currency")); com_Column = var_Column;
com_Column.Def(17/*exCaptionFormat*/,COMVariant::createFromInt(1));
com_Column.FormatColumn("len(value) ? ((0:=dbl(value)) < 10 ? '<fgcolor=808080><font ;7>' : '<b>') + currency(=:0)");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add("1.23");
com_Items.Add("2.34");
com_Items.Add("9.94");
com_Items.Add("11.94");
com_Items.Add("1000");
}
|
|
374
|
How can I highlight only parts of the cells
public void init()
{
COM com_Column,com_Items;
anytype var_Column,var_Items;
int h;
;
super();
var_Column = COM::createFromVariant(exlist1.Columns().Add("")); com_Column = var_Column;
com_Column.Def(17/*exCaptionFormat*/,COMVariant::createFromInt(1));
com_Column.FormatColumn("value replace 'hil' with '<fgcolor=FF0000><b>hil</b></fgcolor>'");
var_Items = exlist1.Items(); com_Items = var_Items;
h = com_Items.Add("Root");
com_Items.Add("Child 1");
com_Items.Add("Child 2");
com_Items.Add("Child 3");
}
|
|
373
|
How can I get the number of occurrences of a specified string in the cell
public void init()
{
COM com_Column,com_Items;
anytype var_Column,var_Items;
int h;
;
super();
exlist1.Columns().Add("");
var_Column = COM::createFromVariant(exlist1.Columns().Add("occurrences")); com_Column = var_Column;
com_Column.ComputedField("lower(%0) count 'o'");
com_Column.FormatColumn("'contains ' + value + ' of \\'o\\' chars'");
var_Items = exlist1.Items(); com_Items = var_Items;
h = com_Items.Add("Root");
com_Items.Add("Child 1 oooof the root");
com_Items.Add("Child 2");
com_Items.Add("Child 3");
}
|
|
372
|
How can I display dates in my format
public void init()
{
COM com_Column,com_Items;
anytype var_Column,var_Items;
;
super();
var_Column = COM::createFromVariant(exlist1.Columns().Add("Date")); com_Column = var_Column;
com_Column.Def(17/*exCaptionFormat*/,COMVariant::createFromInt(1));
com_Column.FormatColumn("'<b>' + year(0:=date(value)) + '</b><fgcolor=808080><font ;6> (' + month(=:0) + ' - ' + day(=:0) +')'");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add(COMVariant::createFromDate(str2Date("1/21/2001",213)));
com_Items.Add(COMVariant::createFromDate(str2Date("2/22/2002",213)));
com_Items.Add(COMVariant::createFromDate(str2Date("3/13/2003",213)));
com_Items.Add(COMVariant::createFromDate(str2Date("4/24/2004",213)));
}
|
|
371
|
How can I display dates in short format
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
COM::createFromVariant(exlist1.Columns().Add("Date")).FormatColumn("shortdate(value)");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add(COMVariant::createFromDate(str2Date("1/1/2001",213)));
com_Items.Add(COMVariant::createFromDate(str2Date("2/2/2002",213)));
com_Items.Add(COMVariant::createFromDate(str2Date("3/3/2003",213)));
com_Items.Add(COMVariant::createFromDate(str2Date("4/4/2004",213)));
}
|
|
370
|
How can I display dates in long format
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
COM::createFromVariant(exlist1.Columns().Add("Date")).FormatColumn("longdate(value)");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add(COMVariant::createFromDate(str2Date("1/1/2001",213)));
com_Items.Add(COMVariant::createFromDate(str2Date("2/2/2002",213)));
com_Items.Add(COMVariant::createFromDate(str2Date("3/3/2003",213)));
com_Items.Add(COMVariant::createFromDate(str2Date("4/4/2004",213)));
}
|
|
369
|
How can I display only the right part of the cell
public void init()
{
COM com_Column,com_Items;
anytype var_Column,var_Items;
int h;
;
super();
exlist1.Columns().Add("");
var_Column = COM::createFromVariant(exlist1.Columns().Add("Right")); com_Column = var_Column;
com_Column.ComputedField("%0 right 2");
com_Column.FormatColumn("'\"' + value + '\"'");
var_Items = exlist1.Items(); com_Items = var_Items;
h = com_Items.Add("Root");
com_Items.Add("Child 1");
com_Items.Add("Child 2");
com_Items.Add("SChild 3");
}
|
|
368
|
How can I display only the left part of the cell
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
exlist1.Columns().Add("");
COM::createFromVariant(exlist1.Columns().Add("Left")).ComputedField("%0 left 2");
var_Items = exlist1.Items(); com_Items = var_Items;
h = com_Items.Add("Root");
com_Items.Add("Child 1");
com_Items.Add("Child 2");
com_Items.Add("SChild 3");
}
|
|
367
|
How can I display true or false instead 0 and -1
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
COM::createFromVariant(exlist1.Columns().Add("Boolean")).FormatColumn("value != 0 ? 'true' : 'false'");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add(COMVariant::createFromBoolean(true));
com_Items.Add(COMVariant::createFromBoolean(false));
com_Items.Add(COMVariant::createFromBoolean(true));
com_Items.Add(COMVariant::createFromInt(0));
com_Items.Add(COMVariant::createFromInt(1));
}
|
|
366
|
How can I display icons or images instead numbers
public void init()
{
COM com_Column,com_Items;
anytype var_Column,var_Items;
str var_s;
;
super();
var_s = "gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTql";
var_s = var_s + "Vq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0";
var_s = var_s + "ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/yN";
var_s = var_s + "AOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=";
exlist1.Images(COMVariant::createFromStr(var_s));
var_Column = COM::createFromVariant(exlist1.Columns().Add("Icons")); com_Column = var_Column;
com_Column.Def(17/*exCaptionFormat*/,COMVariant::createFromInt(1));
com_Column.FormatColumn("'The cell displays the icon <img>'+value+'</img> instead ' + value");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add(COMVariant::createFromInt(1));
com_Items.Add(COMVariant::createFromInt(2));
com_Items.Add(COMVariant::createFromInt(3));
}
|
|
365
|
How can I display the column using currency
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
COM::createFromVariant(exlist1.Columns().Add("Currency")).FormatColumn("currency(dbl(value))");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add("1.23");
com_Items.Add("2.34");
com_Items.Add("0");
com_Items.Add(COMVariant::createFromInt(5));
com_Items.Add("10000.99");
}
|
|
364
|
Is is possible to use HTML tags to display in the filter caption
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.BeginUpdate();
exlist1.FilterBarPromptVisible(true);
exlist1.FilterBarCaption("This is a bit of text being displayed in the filter bar.");
exlist1.Columns().Add("");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add("Item 1");
com_Items.Add("Item 2");
com_Items.Add("Item 3");
exlist1.EndUpdate();
}
|
|
363
|
How can I find the number of items after filtering
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
exlist1.BeginUpdate();
exlist1.Columns().Add("");
var_Items = exlist1.Items(); com_Items = var_Items;
h = com_Items.Add("");
com_Items.Caption(h,COMVariant::createFromInt(0),com_Items.VisibleItemCount());
exlist1.EndUpdate();
}
|
|
362
|
How can I change the filter caption
public void init()
{
COM com_Columns,com_Items;
anytype var_Columns,var_Items;
int h0;
;
super();
exlist1.BeginUpdate();
exlist1.ColumnAutoResize(true);
exlist1.ContinueColumnScroll(0);
exlist1.MarkSearchColumn(false);
exlist1.SearchColumnIndex(1);
exlist1.FilterBarPromptVisible(true);
exlist1.FilterBarPromptType(12801/*exFilterPromptWords | exFilterPromptContainsAll*/);
exlist1.FilterBarPromptPattern("london robert");
exlist1.FilterBarCaption("<r>Found: ... ");
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
COM::createFromVariant(com_Columns.Add("Name")).Width(96);
COM::createFromVariant(com_Columns.Add("Title")).Width(96);
com_Columns.Add("City");
var_Items = exlist1.Items(); com_Items = var_Items;
h0 = com_Items.Add("Nancy Davolio");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Andrew Fuller");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Vice President, Sales");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Tacoma");
com_Items.SelectItem(h0,true);
h0 = com_Items.Add("Janet Leverling");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Kirkland");
h0 = com_Items.Add("Margaret Peacock");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Redmond");
h0 = com_Items.Add("Steven Buchanan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Manager");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Michael Suyama");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Robert King");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Laura Callahan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Inside Sales Coordinator");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Anne Dodsworth");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
exlist1.EndUpdate();
}
|
|
361
|
While using the filter prompt is it is possible to use wild characters
public void init()
{
COM com_Columns,com_Items;
anytype var_Columns,var_Items;
int h0;
;
super();
exlist1.BeginUpdate();
exlist1.ColumnAutoResize(true);
exlist1.ContinueColumnScroll(0);
exlist1.MarkSearchColumn(false);
exlist1.SearchColumnIndex(1);
exlist1.FilterBarPromptVisible(true);
exlist1.FilterBarPromptType(16/*exFilterPromptPattern*/);
exlist1.FilterBarPromptPattern("lon* seat*");
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
COM::createFromVariant(com_Columns.Add("Name")).Width(96);
COM::createFromVariant(com_Columns.Add("Title")).Width(96);
com_Columns.Add("City");
var_Items = exlist1.Items(); com_Items = var_Items;
h0 = com_Items.Add("Nancy Davolio");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Andrew Fuller");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Vice President, Sales");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Tacoma");
com_Items.SelectItem(h0,true);
h0 = com_Items.Add("Janet Leverling");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Kirkland");
h0 = com_Items.Add("Margaret Peacock");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Redmond");
h0 = com_Items.Add("Steven Buchanan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Manager");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Michael Suyama");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Robert King");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Laura Callahan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Inside Sales Coordinator");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Anne Dodsworth");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
exlist1.EndUpdate();
}
|
|
360
|
How can I list all items that contains any of specified words, not necessary at the beggining
public void init()
{
COM com_Columns,com_Items;
anytype var_Columns,var_Items;
int h0;
;
super();
exlist1.BeginUpdate();
exlist1.ColumnAutoResize(true);
exlist1.ContinueColumnScroll(0);
exlist1.MarkSearchColumn(false);
exlist1.SearchColumnIndex(1);
exlist1.FilterBarPromptVisible(true);
exlist1.FilterBarPromptType(4610/*exFilterPromptStartWords | exFilterPromptContainsAny*/);
exlist1.FilterBarPromptPattern("london davolio");
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
COM::createFromVariant(com_Columns.Add("Name")).Width(96);
COM::createFromVariant(com_Columns.Add("Title")).Width(96);
com_Columns.Add("City");
var_Items = exlist1.Items(); com_Items = var_Items;
h0 = com_Items.Add("Nancy Davolio");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Andrew Fuller");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Vice President, Sales");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Tacoma");
com_Items.SelectItem(h0,true);
h0 = com_Items.Add("Janet Leverling");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Kirkland");
h0 = com_Items.Add("Margaret Peacock");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Redmond");
h0 = com_Items.Add("Steven Buchanan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Manager");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Michael Suyama");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Robert King");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Laura Callahan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Inside Sales Coordinator");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Anne Dodsworth");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
exlist1.EndUpdate();
}
|
|
359
|
How can I list all items that contains any of specified words, not strings
public void init()
{
COM com_Columns,com_Items;
anytype var_Columns,var_Items;
int h0;
;
super();
exlist1.BeginUpdate();
exlist1.ColumnAutoResize(true);
exlist1.ContinueColumnScroll(0);
exlist1.MarkSearchColumn(false);
exlist1.SearchColumnIndex(1);
exlist1.FilterBarPromptVisible(true);
exlist1.FilterBarPromptType(12802/*exFilterPromptWords | exFilterPromptContainsAny*/);
exlist1.FilterBarPromptPattern("london nancy");
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
COM::createFromVariant(com_Columns.Add("Name")).Width(96);
COM::createFromVariant(com_Columns.Add("Title")).Width(96);
com_Columns.Add("City");
var_Items = exlist1.Items(); com_Items = var_Items;
h0 = com_Items.Add("Nancy Davolio");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Andrew Fuller");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Vice President, Sales");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Tacoma");
com_Items.SelectItem(h0,true);
h0 = com_Items.Add("Janet Leverling");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Kirkland");
h0 = com_Items.Add("Margaret Peacock");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Redmond");
h0 = com_Items.Add("Steven Buchanan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Manager");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Michael Suyama");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Robert King");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Laura Callahan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Inside Sales Coordinator");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Anne Dodsworth");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
exlist1.EndUpdate();
}
|
|
358
|
How can I list all items that contains all specified words, not strings
public void init()
{
COM com_Columns,com_Items;
anytype var_Columns,var_Items;
int h0;
;
super();
exlist1.BeginUpdate();
exlist1.ColumnAutoResize(true);
exlist1.ContinueColumnScroll(0);
exlist1.MarkSearchColumn(false);
exlist1.SearchColumnIndex(1);
exlist1.FilterBarPromptVisible(true);
exlist1.FilterBarPromptType(12801/*exFilterPromptWords | exFilterPromptContainsAll*/);
exlist1.FilterBarPromptPattern("london robert");
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
COM::createFromVariant(com_Columns.Add("Name")).Width(96);
COM::createFromVariant(com_Columns.Add("Title")).Width(96);
com_Columns.Add("City");
var_Items = exlist1.Items(); com_Items = var_Items;
h0 = com_Items.Add("Nancy Davolio");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Andrew Fuller");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Vice President, Sales");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Tacoma");
com_Items.SelectItem(h0,true);
h0 = com_Items.Add("Janet Leverling");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Kirkland");
h0 = com_Items.Add("Margaret Peacock");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Redmond");
h0 = com_Items.Add("Steven Buchanan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Manager");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Michael Suyama");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Robert King");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Laura Callahan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Inside Sales Coordinator");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Anne Dodsworth");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
exlist1.EndUpdate();
}
|
|
357
|
I've noticed that the filtering by prompt is not case sensitive, is is possible to make it case sensitive
public void init()
{
COM com_Columns,com_Items;
anytype var_Columns,var_Items;
int h0;
;
super();
exlist1.BeginUpdate();
exlist1.ColumnAutoResize(true);
exlist1.ContinueColumnScroll(0);
exlist1.MarkSearchColumn(false);
exlist1.SearchColumnIndex(1);
exlist1.FilterBarPromptVisible(true);
exlist1.FilterBarPromptType(258/*exFilterPromptCaseSensitive | exFilterPromptContainsAny*/);
exlist1.FilterBarPromptPattern("Anne");
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
COM::createFromVariant(com_Columns.Add("Name")).Width(96);
COM::createFromVariant(com_Columns.Add("Title")).Width(96);
com_Columns.Add("City");
var_Items = exlist1.Items(); com_Items = var_Items;
h0 = com_Items.Add("Nancy Davolio");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Andrew Fuller");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Vice President, Sales");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Tacoma");
com_Items.SelectItem(h0,true);
h0 = com_Items.Add("Janet Leverling");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Kirkland");
h0 = com_Items.Add("Margaret Peacock");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Redmond");
h0 = com_Items.Add("Steven Buchanan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Manager");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Michael Suyama");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Robert King");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Laura Callahan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Inside Sales Coordinator");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Anne Dodsworth");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
exlist1.EndUpdate();
}
|
|
356
|
Is it possible to list only items that ends with any of specified strings
public void init()
{
COM com_Columns,com_Items;
anytype var_Columns,var_Items;
int h0;
;
super();
exlist1.BeginUpdate();
exlist1.ColumnAutoResize(true);
exlist1.ContinueColumnScroll(0);
exlist1.MarkSearchColumn(false);
exlist1.SearchColumnIndex(1);
exlist1.FilterBarPromptVisible(true);
exlist1.FilterBarPromptType(4/*exFilterPromptEndWith*/);
exlist1.FilterBarPromptColumns("0");
exlist1.FilterBarPromptPattern("Fuller");
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
COM::createFromVariant(com_Columns.Add("Name")).Width(96);
COM::createFromVariant(com_Columns.Add("Title")).Width(96);
com_Columns.Add("City");
var_Items = exlist1.Items(); com_Items = var_Items;
h0 = com_Items.Add("Nancy Davolio");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Andrew Fuller");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Vice President, Sales");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Tacoma");
com_Items.SelectItem(h0,true);
h0 = com_Items.Add("Janet Leverling");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Kirkland");
h0 = com_Items.Add("Margaret Peacock");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Redmond");
h0 = com_Items.Add("Steven Buchanan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Manager");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Michael Suyama");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Robert King");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Laura Callahan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Inside Sales Coordinator");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Anne Dodsworth");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
exlist1.EndUpdate();
}
|
|
355
|
Is it possible to list only items that ends with any of specified strings
public void init()
{
COM com_Columns,com_Items;
anytype var_Columns,var_Items;
int h0;
;
super();
exlist1.BeginUpdate();
exlist1.ColumnAutoResize(true);
exlist1.ContinueColumnScroll(0);
exlist1.MarkSearchColumn(false);
exlist1.SearchColumnIndex(1);
exlist1.FilterBarPromptVisible(true);
exlist1.FilterBarPromptType(4/*exFilterPromptEndWith*/);
exlist1.FilterBarPromptColumns("0");
exlist1.FilterBarPromptPattern("Fuller");
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
COM::createFromVariant(com_Columns.Add("Name")).Width(96);
COM::createFromVariant(com_Columns.Add("Title")).Width(96);
com_Columns.Add("City");
var_Items = exlist1.Items(); com_Items = var_Items;
h0 = com_Items.Add("Nancy Davolio");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Andrew Fuller");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Vice President, Sales");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Tacoma");
com_Items.SelectItem(h0,true);
h0 = com_Items.Add("Janet Leverling");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Kirkland");
h0 = com_Items.Add("Margaret Peacock");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Redmond");
h0 = com_Items.Add("Steven Buchanan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Manager");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Michael Suyama");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Robert King");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Laura Callahan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Inside Sales Coordinator");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Anne Dodsworth");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
exlist1.EndUpdate();
}
|
|
354
|
Is it possible to list only items that starts with any of specified strings
public void init()
{
COM com_Columns,com_Items;
anytype var_Columns,var_Items;
int h0;
;
super();
exlist1.BeginUpdate();
exlist1.ColumnAutoResize(true);
exlist1.ContinueColumnScroll(0);
exlist1.MarkSearchColumn(false);
exlist1.SearchColumnIndex(1);
exlist1.FilterBarPromptVisible(true);
exlist1.FilterBarPromptType(3/*exFilterPromptStartWith*/);
exlist1.FilterBarPromptColumns("0");
exlist1.FilterBarPromptPattern("An M");
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
COM::createFromVariant(com_Columns.Add("Name")).Width(96);
COM::createFromVariant(com_Columns.Add("Title")).Width(96);
com_Columns.Add("City");
var_Items = exlist1.Items(); com_Items = var_Items;
h0 = com_Items.Add("Nancy Davolio");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Andrew Fuller");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Vice President, Sales");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Tacoma");
com_Items.SelectItem(h0,true);
h0 = com_Items.Add("Janet Leverling");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Kirkland");
h0 = com_Items.Add("Margaret Peacock");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Redmond");
h0 = com_Items.Add("Steven Buchanan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Manager");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Michael Suyama");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Robert King");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Laura Callahan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Inside Sales Coordinator");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Anne Dodsworth");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
exlist1.EndUpdate();
}
|
|
353
|
Is it possible to list only items that starts with specified string
public void init()
{
COM com_Columns,com_Items;
anytype var_Columns,var_Items;
int h0;
;
super();
exlist1.BeginUpdate();
exlist1.ColumnAutoResize(true);
exlist1.ContinueColumnScroll(0);
exlist1.MarkSearchColumn(false);
exlist1.SearchColumnIndex(1);
exlist1.FilterBarPromptVisible(true);
exlist1.FilterBarPromptType(3/*exFilterPromptStartWith*/);
exlist1.FilterBarPromptColumns("0");
exlist1.FilterBarPromptPattern("A");
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
COM::createFromVariant(com_Columns.Add("Name")).Width(96);
COM::createFromVariant(com_Columns.Add("Title")).Width(96);
com_Columns.Add("City");
var_Items = exlist1.Items(); com_Items = var_Items;
h0 = com_Items.Add("Nancy Davolio");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Andrew Fuller");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Vice President, Sales");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Tacoma");
com_Items.SelectItem(h0,true);
h0 = com_Items.Add("Janet Leverling");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Kirkland");
h0 = com_Items.Add("Margaret Peacock");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Redmond");
h0 = com_Items.Add("Steven Buchanan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Manager");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Michael Suyama");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Robert King");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Laura Callahan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Inside Sales Coordinator");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Anne Dodsworth");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
exlist1.EndUpdate();
}
|
|
352
|
How can I specify that the list should include any of the seqeunces in the pattern
public void init()
{
COM com_Columns,com_Items;
anytype var_Columns,var_Items;
int h0;
;
super();
exlist1.BeginUpdate();
exlist1.ColumnAutoResize(true);
exlist1.ContinueColumnScroll(0);
exlist1.MarkSearchColumn(false);
exlist1.SearchColumnIndex(1);
exlist1.FilterBarPromptVisible(true);
exlist1.FilterBarPromptType(2/*exFilterPromptContainsAny*/);
exlist1.FilterBarPromptPattern("london seattle");
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
COM::createFromVariant(com_Columns.Add("Name")).Width(96);
COM::createFromVariant(com_Columns.Add("Title")).Width(96);
com_Columns.Add("City");
var_Items = exlist1.Items(); com_Items = var_Items;
h0 = com_Items.Add("Nancy Davolio");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Andrew Fuller");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Vice President, Sales");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Tacoma");
com_Items.SelectItem(h0,true);
h0 = com_Items.Add("Janet Leverling");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Kirkland");
h0 = com_Items.Add("Margaret Peacock");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Redmond");
h0 = com_Items.Add("Steven Buchanan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Manager");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Michael Suyama");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Robert King");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Laura Callahan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Inside Sales Coordinator");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Anne Dodsworth");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
exlist1.EndUpdate();
}
|
|
351
|
How can I specify that all sequences in the filter pattern must be included in the list
public void init()
{
COM com_Columns,com_Items;
anytype var_Columns,var_Items;
int h0;
;
super();
exlist1.BeginUpdate();
exlist1.ColumnAutoResize(true);
exlist1.ContinueColumnScroll(0);
exlist1.MarkSearchColumn(false);
exlist1.SearchColumnIndex(1);
exlist1.FilterBarPromptVisible(true);
exlist1.FilterBarPromptType(1/*exFilterPromptContainsAll*/);
exlist1.FilterBarPromptPattern("london manager");
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
COM::createFromVariant(com_Columns.Add("Name")).Width(96);
COM::createFromVariant(com_Columns.Add("Title")).Width(96);
com_Columns.Add("City");
var_Items = exlist1.Items(); com_Items = var_Items;
h0 = com_Items.Add("Nancy Davolio");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Andrew Fuller");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Vice President, Sales");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Tacoma");
com_Items.SelectItem(h0,true);
h0 = com_Items.Add("Janet Leverling");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Kirkland");
h0 = com_Items.Add("Margaret Peacock");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Redmond");
h0 = com_Items.Add("Steven Buchanan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Manager");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Michael Suyama");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Robert King");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Laura Callahan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Inside Sales Coordinator");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Anne Dodsworth");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
exlist1.EndUpdate();
}
|
|
350
|
How do I change at runtime the filter prompt
public void init()
{
COM com_Columns,com_Items;
anytype var_Columns,var_Items;
int h0;
;
super();
exlist1.BeginUpdate();
exlist1.ColumnAutoResize(true);
exlist1.ContinueColumnScroll(0);
exlist1.MarkSearchColumn(false);
exlist1.SearchColumnIndex(1);
exlist1.FilterBarPromptVisible(true);
exlist1.FilterBarPromptPattern("london manager");
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
COM::createFromVariant(com_Columns.Add("Name")).Width(96);
COM::createFromVariant(com_Columns.Add("Title")).Width(96);
com_Columns.Add("City");
var_Items = exlist1.Items(); com_Items = var_Items;
h0 = com_Items.Add("Nancy Davolio");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Andrew Fuller");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Vice President, Sales");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Tacoma");
com_Items.SelectItem(h0,true);
h0 = com_Items.Add("Janet Leverling");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Kirkland");
h0 = com_Items.Add("Margaret Peacock");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Redmond");
h0 = com_Items.Add("Steven Buchanan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Manager");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Michael Suyama");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Robert King");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Laura Callahan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Inside Sales Coordinator");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Anne Dodsworth");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
exlist1.EndUpdate();
}
|
|
349
|
How do I specify to filter only a single column when using the filter prompt
public void init()
{
COM com_Columns,com_Items;
anytype var_Columns,var_Items;
int h0;
;
super();
exlist1.BeginUpdate();
exlist1.ColumnAutoResize(true);
exlist1.ContinueColumnScroll(0);
exlist1.MarkSearchColumn(false);
exlist1.SearchColumnIndex(1);
exlist1.FilterBarPromptVisible(true);
exlist1.FilterBarPromptColumns("2,3");
exlist1.FilterBarPromptPattern("london");
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
COM::createFromVariant(com_Columns.Add("Name")).Width(96);
COM::createFromVariant(com_Columns.Add("Title")).Width(96);
com_Columns.Add("City");
var_Items = exlist1.Items(); com_Items = var_Items;
h0 = com_Items.Add("Nancy Davolio");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Andrew Fuller");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Vice President, Sales");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Tacoma");
com_Items.SelectItem(h0,true);
h0 = com_Items.Add("Janet Leverling");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Kirkland");
h0 = com_Items.Add("Margaret Peacock");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Redmond");
h0 = com_Items.Add("Steven Buchanan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Manager");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Michael Suyama");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Robert King");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Laura Callahan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Inside Sales Coordinator");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Anne Dodsworth");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
exlist1.EndUpdate();
}
|
|
348
|
How do I change the prompt or the caption being displayed in the filter bar
public void init()
{
COM com_Columns;
anytype var_Columns;
;
super();
exlist1.BeginUpdate();
exlist1.ColumnAutoResize(true);
exlist1.ContinueColumnScroll(0);
exlist1.MarkSearchColumn(false);
exlist1.SearchColumnIndex(1);
exlist1.FilterBarPromptVisible(true);
exlist1.FilterBarPrompt("changed");
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
COM::createFromVariant(com_Columns.Add("Name")).Width(96);
COM::createFromVariant(com_Columns.Add("Title")).Width(96);
com_Columns.Add("City");
exlist1.EndUpdate();
}
|
|
347
|
How do I enable the filter prompt feature
public void init()
{
COM com_Columns,com_Items;
anytype var_Columns,var_Items;
int h0;
;
super();
exlist1.BeginUpdate();
exlist1.ColumnAutoResize(true);
exlist1.ContinueColumnScroll(0);
exlist1.MarkSearchColumn(false);
exlist1.SearchColumnIndex(1);
exlist1.FilterBarPromptVisible(true);
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
COM::createFromVariant(com_Columns.Add("Name")).Width(96);
COM::createFromVariant(com_Columns.Add("Title")).Width(96);
com_Columns.Add("City");
var_Items = exlist1.Items(); com_Items = var_Items;
h0 = com_Items.Add("Nancy Davolio");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Andrew Fuller");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Vice President, Sales");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Tacoma");
com_Items.SelectItem(h0,true);
h0 = com_Items.Add("Janet Leverling");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Kirkland");
h0 = com_Items.Add("Margaret Peacock");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Redmond");
h0 = com_Items.Add("Steven Buchanan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Manager");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Michael Suyama");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Robert King");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
h0 = com_Items.Add("Laura Callahan");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Inside Sales Coordinator");
com_Items.Caption(h0,COMVariant::createFromInt(2),"Seattle");
h0 = com_Items.Add("Anne Dodsworth");
com_Items.Caption(h0,COMVariant::createFromInt(1),"Sales Representative");
com_Items.Caption(h0,COMVariant::createFromInt(2),"London");
exlist1.EndUpdate();
}
|
|
346
|
Is it possible to change the style for the vertical or horizontal grid lines, in the list area
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
exlist1.BeginUpdate();
exlist1.DrawGridLines(-1/*exAllLines*/);
exlist1.GridLineStyle(33/*exGridLinesVSolid | exGridLinesHDot4*/);
exlist1.Columns().Add("C1");
exlist1.Columns().Add("C2");
exlist1.Columns().Add("C3");
var_Items = exlist1.Items(); com_Items = var_Items;
h = com_Items.Add("Item 1");
com_Items.Caption(h,COMVariant::createFromInt(1),"SubItem 1.2");
com_Items.Caption(h,COMVariant::createFromInt(2),"SubItem 1.3");
h = com_Items.Add("Item 2");
com_Items.Caption(h,COMVariant::createFromInt(1),"SubItem 2.2");
com_Items.Caption(h,COMVariant::createFromInt(2),"SubItem 2.3");
exlist1.EndUpdate();
}
|
|
345
|
Is it possible to change the style for the grid lines, for instance to be solid not dotted
public void init()
{
;
super();
exlist1.BeginUpdate();
exlist1.DrawGridLines(-1/*exAllLines*/);
exlist1.GridLineStyle(48/*exGridLinesSolid*/);
exlist1.Columns().Add("Column");
exlist1.EndUpdate();
}
|
|
344
|
How can I filter programatically using more columns
public void init()
{
COM com_Column,com_Column1,com_Columns,com_Items;
anytype var_Column,var_Column1,var_Columns,var_Items;
;
super();
exlist1.BeginUpdate();
exlist1.MarkSearchColumn(false);
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
com_Columns.Add("Car");
com_Columns.Add("Equipment");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Caption(com_Items.Add("Mazda"),COMVariant::createFromInt(1),"Air Bag");
com_Items.Caption(com_Items.Add("Toyota"),COMVariant::createFromInt(1),"Air Bag,Air condition");
com_Items.Caption(com_Items.Add("Ford"),COMVariant::createFromInt(1),"Air condition");
com_Items.Caption(com_Items.Add("Nissan"),COMVariant::createFromInt(1),"Air Bag,ABS,ESP");
com_Items.Caption(com_Items.Add("Mazda"),COMVariant::createFromInt(1),"Air Bag, ABS,ESP");
com_Items.Caption(com_Items.Add("Mazda"),COMVariant::createFromInt(1),"ABS,ESP");
var_Column = COM::createFromObject(exlist1.Columns()).Item("Car"); com_Column = var_Column;
com_Column.FilterType(240/*exFilter*/);
com_Column.Filter("Mazda");
var_Column1 = COM::createFromObject(exlist1.Columns()).Item("Equipment"); com_Column1 = var_Column1;
com_Column1.FilterType(3/*exPattern*/);
com_Column1.Filter("*ABS*|*ESP*");
exlist1.ApplyFilter();
exlist1.EndUpdate();
}
|
|
343
|
How do I find an item based on my extra data
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.Columns().Add("Default");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add("Item 1");
com_Items.Add("Item 2");
com_Items.ItemData(com_Items.Add("Item 3"),COMVariant::createFromInt(1234));
com_Items.Add("Item 4");
com_Items.ItemBold(com_Items.FindItemData(COMVariant::createFromInt(1234)),true);
}
|
|
342
|
How do I print the control's content
public void init()
{
COM com_Items,com_Print;
anytype var_Items,var_Print;
;
super();
exlist1.BeginUpdate();
exlist1.Columns().Add("Number");
COM::createFromVariant(exlist1.Columns().Add("Currency")).ComputedField("len(%0) ? currency(dbl(%0)) : ''");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add("1.23");
com_Items.Add("2.34");
com_Items.Add("0");
com_Items.ItemBackColor(com_Items.Add(),WinApi::RGB2int(255,128,128));
com_Items.Add("10000.99");
exlist1.EndUpdate();
// Add 'exprint.dll(ExPrint.dll)' reference to your project.
// Add 'ExPrint 1.0 Control Library(ExPrint.dll)' reference to your project.
var_Print = COM::createFromObject(new EXPRINTLib.exprint()); com_Print = var_Print;
com_Print.PrintExt(exlist1);
com_Print.Preview();
}
|
|
341
|
How can I display the currency only for not empty cells
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.Columns().Add("Number");
COM::createFromVariant(exlist1.Columns().Add("Currency")).ComputedField("len(%0) ? currency(dbl(%0)) : ''");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add("1.23");
com_Items.Add("2.34");
com_Items.Add("0");
com_Items.ItemBackColor(com_Items.Add(),WinApi::RGB2int(255,128,128));
com_Items.Add("10000.99");
}
|
|
340
|
Is there a function to display the number of days between two date including the number of hours
public void init()
{
COM com_Items;
anytype var_Items;
int h;
str var_s;
;
super();
COM::createFromVariant(exlist1.Columns().Add("Start")).Width(32);
exlist1.Columns().Add("End");
var_s = "2:=((1:=int(0:= date(%1)-date(%0))) = 0 ? '' : str(=:1) + ' day(s)') + ( 3:=round(24*(=:0-floor(=:0))) ? (len(=:2) ? ' and ' : '";
var_s = var_s + "') + =:3 + ' hour(s)' : '' )";
COM::createFromVariant(exlist1.Columns().Add("Duration")).ComputedField(var_s);
var_Items = exlist1.Items(); com_Items = var_Items;
h = com_Items.Add(COMVariant::createFromDate(str2Date("1/11/2001",213)));
com_Items.Caption(h,COMVariant::createFromInt(1),COMVariant::createFromDate(str2Date("1/14/2001",213)));
h = com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("2/22/2002 12:00:00",213)));
com_Items.Caption(h,COMVariant::createFromInt(1),COMVariant::createFromUtcDateTime(str2Datetime("3/14/2002 13:00:00",213)));
h = com_Items.Add(COMVariant::createFromDate(str2Date("3/13/2003",213)));
com_Items.Caption(h,COMVariant::createFromInt(1),COMVariant::createFromUtcDateTime(str2Datetime("4/11/2003 11:00:00",213)));
}
|
|
339
|
Is there a function to display the number of days between two date including the number of hours
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
exlist1.Columns().Add("Start");
exlist1.Columns().Add("End");
COM::createFromVariant(exlist1.Columns().Add("Duration")).ComputedField("\"D \" + int(date(%1)-date(%0)) + \" H \" + round(24*(date(%1)-date(%0) - floor(date(%1)-date(%0))))");
var_Items = exlist1.Items(); com_Items = var_Items;
h = com_Items.Add(COMVariant::createFromDate(str2Date("1/11/2001",213)));
com_Items.Caption(h,COMVariant::createFromInt(1),COMVariant::createFromUtcDateTime(str2Datetime("1/14/2001 23:00:00",213)));
h = com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("2/22/2002 12:00:00",213)));
com_Items.Caption(h,COMVariant::createFromInt(1),COMVariant::createFromUtcDateTime(str2Datetime("3/14/2002 13:00:00",213)));
h = com_Items.Add(COMVariant::createFromDate(str2Date("3/13/2003",213)));
com_Items.Caption(h,COMVariant::createFromInt(1),COMVariant::createFromUtcDateTime(str2Datetime("4/11/2003 11:00:00",213)));
}
|
|
338
|
How can I display the number of days between two dates
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
exlist1.Columns().Add("Start");
exlist1.Columns().Add("End");
COM::createFromVariant(exlist1.Columns().Add("Duration")).ComputedField("(date(%1)-date(%0)) + ' days'");
var_Items = exlist1.Items(); com_Items = var_Items;
h = com_Items.Add(COMVariant::createFromDate(str2Date("1/11/2001",213)));
com_Items.Caption(h,COMVariant::createFromInt(1),COMVariant::createFromDate(str2Date("1/14/2001",213)));
h = com_Items.Add(COMVariant::createFromDate(str2Date("2/22/2002",213)));
com_Items.Caption(h,COMVariant::createFromInt(1),COMVariant::createFromDate(str2Date("3/14/2002",213)));
h = com_Items.Add(COMVariant::createFromDate(str2Date("3/13/2003",213)));
com_Items.Caption(h,COMVariant::createFromInt(1),COMVariant::createFromDate(str2Date("4/11/2003",213)));
}
|
|
337
|
How can I get second part of the date
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.Columns().Add("Date");
COM::createFromVariant(exlist1.Columns().Add("Second")).ComputedField("sec(date(%0))");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("1/11/2001 10:10:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("2/22/2002 11:01:22",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("3/13/2003 12:23:01",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("4/14/2004 13:11:59",213)));
}
|
|
336
|
How can I get minute part of the date
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.Columns().Add("Date");
COM::createFromVariant(exlist1.Columns().Add("Minute")).ComputedField("min(date(%0))");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("1/11/2001 10:10:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("2/22/2002 11:01:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("3/13/2003 12:23:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("4/14/2004 13:11:00",213)));
}
|
|
335
|
How can I check the hour part only so I know it was afternoon
public void init()
{
COM com_ConditionalFormat,com_Items;
anytype var_ConditionalFormat,var_Items;
;
super();
var_ConditionalFormat = COM::createFromObject(exlist1.ConditionalFormats()).Add("hour(%0)>=12"); com_ConditionalFormat = var_ConditionalFormat;
com_ConditionalFormat.Bold(true);
exlist1.Columns().Add("Date");
COM::createFromVariant(exlist1.Columns().Add("Hour")).ComputedField("hour(%0)");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("1/11/2001 10:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("2/22/2002 11:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("3/13/2003 12:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("4/14/2004 13:00:00",213)));
}
|
|
334
|
What about a function to get the day in the week, or days since Sunday
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.Columns().Add("Date");
COM::createFromVariant(exlist1.Columns().Add("WeekDay")).ComputedField("weekday(%0)");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("1/11/2001 10:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("2/22/2002 11:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("3/13/2003 12:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("4/14/2004 13:00:00",213)));
}
|
|
333
|
Is there any function to get the day of the year or number of days since January 1st
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.Columns().Add("Date");
COM::createFromVariant(exlist1.Columns().Add("Day since January 1st")).ComputedField("yearday(%0)");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("1/11/2001 10:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("2/22/2002 11:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("3/13/2003 12:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("4/14/2004 13:00:00",213)));
}
|
|
332
|
How can I display only the day of the date
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.Columns().Add("Date");
COM::createFromVariant(exlist1.Columns().Add("Day")).ComputedField("day(%0)");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("1/11/2001 10:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("2/22/2002 11:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("3/13/2003 12:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("4/14/2004 13:00:00",213)));
}
|
|
331
|
How can I display only the month of the date
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.Columns().Add("Date");
COM::createFromVariant(exlist1.Columns().Add("Month")).ComputedField("month(%0)");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("1/1/2001 10:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("2/2/2002 11:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("3/3/2003 12:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("4/4/2004 13:00:00",213)));
}
|
|
330
|
How can I get only the year part from a date expression
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.Columns().Add("Date");
COM::createFromVariant(exlist1.Columns().Add("Year")).ComputedField("year(%0)");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("1/1/2001 10:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("2/2/2002 11:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("3/3/2003 12:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("4/4/2004 13:00:00",213)));
}
|
|
329
|
Can I convert the expression to date
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.Columns().Add("Number");
COM::createFromVariant(exlist1.Columns().Add("Date")).ComputedField("date(dbl(%0))");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add("-1.98");
com_Items.Add("30000.99");
com_Items.Add("3561.23");
com_Items.Add("1232.34");
}
|
|
328
|
Can I convert the expression to a number, double or float
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.Columns().Add("Number");
COM::createFromVariant(exlist1.Columns().Add("Number + 2")).ComputedField("dbl(%0)+2");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add("-1.98");
com_Items.Add("0.99");
com_Items.Add("1.23");
com_Items.Add("2.34");
}
|
|
327
|
How can I display dates in long format
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.Columns().Add("Date");
COM::createFromVariant(exlist1.Columns().Add("LongFormat")).ComputedField("longdate(%0)");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("1/1/2001 10:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("2/2/2002 11:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("3/3/2003 12:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("4/4/2004 13:00:00",213)));
}
|
|
326
|
How can I display dates in short format
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.Columns().Add("Date");
COM::createFromVariant(exlist1.Columns().Add("ShortFormat")).ComputedField("shortdate(%0)");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("1/1/2001 10:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("2/2/2002 11:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("3/3/2003 12:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("4/4/2004 13:00:00",213)));
}
|
|
325
|
How can I display the time only of a date expression
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.Columns().Add("Date");
COM::createFromVariant(exlist1.Columns().Add("Time")).ComputedField("'time is:' + time(date(%0))");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("1/1/2001 10:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("2/2/2002 11:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("3/3/2003 12:00:00",213)));
com_Items.Add(COMVariant::createFromUtcDateTime(str2Datetime("4/4/2004 13:00:00",213)));
}
|
|
324
|
Is there any function to display currencies, or money formatted as in the control panel
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.Columns().Add("Number");
COM::createFromVariant(exlist1.Columns().Add("Currency")).ComputedField("currency(dbl(%0))");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add("1.23");
com_Items.Add("2.34");
com_Items.Add("10000.99");
}
|
|
323
|
How can I convert the expression to a string so I can look into the date string expression for month's name
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.Columns().Add("Number");
COM::createFromVariant(exlist1.Columns().Add("Str")).ComputedField("str(%0) + ' AA'");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add("-1.98");
com_Items.Add("0.99");
com_Items.Add("1.23");
com_Items.Add("2.34");
}
|
|
322
|
Can I display the absolute value or positive part of the number
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.Columns().Add("Number");
COM::createFromVariant(exlist1.Columns().Add("Abs")).ComputedField("abs(%0)");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add("-1.98");
com_Items.Add("0.99");
com_Items.Add("1.23");
com_Items.Add("2.34");
}
|
|
321
|
Is there any function to get largest number with no fraction part that is not greater than the value
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.Columns().Add("Number");
COM::createFromVariant(exlist1.Columns().Add("Floor")).ComputedField("floor(%0)");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add("-1.98");
com_Items.Add("0.99");
com_Items.Add("1.23");
com_Items.Add("2.34");
}
|
|
320
|
Is there any function to round the values base on the .5 value
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.Columns().Add("Number");
COM::createFromVariant(exlist1.Columns().Add("Round")).ComputedField("round(%0)");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add("-1.98");
com_Items.Add("0.99");
com_Items.Add("1.23");
com_Items.Add("2.34");
}
|
|
319
|
How can I get or display the integer part of the cell
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.Columns().Add("Number");
COM::createFromVariant(exlist1.Columns().Add("Int")).ComputedField("int(%0)");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add("-1.98");
com_Items.Add("0.99");
com_Items.Add("1.23");
com_Items.Add("2.34");
}
|
|
318
|
How can I display names as proper ( first leter of the word must be in uppercase, and the rest in lowercase )
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
COM::createFromVariant(exlist1.Columns().Add("")).ComputedField("proper(%0)");
var_Items = exlist1.Items(); com_Items = var_Items;
h = com_Items.Add("Item 1");
com_Items.Add("item item");
com_Items.Add("item item");
com_Items.Add("item item");
}
|
|
317
|
Is there any option to display cells in uppercase
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
COM::createFromVariant(exlist1.Columns().Add("")).ComputedField("upper(%0)");
var_Items = exlist1.Items(); com_Items = var_Items;
h = com_Items.Add("Item 1");
com_Items.Add("Item 2");
com_Items.Add("Item 3");
com_Items.Add("Item 4 - child");
}
|
|
316
|
Is there any option to display cells in lowercase
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
COM::createFromVariant(exlist1.Columns().Add("")).ComputedField("lower(%0)");
var_Items = exlist1.Items(); com_Items = var_Items;
h = com_Items.Add("Item 1");
com_Items.Add("Item 2");
com_Items.Add("Item 3");
com_Items.Add("Item 4 - child");
}
|
|
315
|
How can I mark the cells that has a specified type, ie strings only
public void init()
{
COM com_ConditionalFormat,com_Items;
anytype var_ConditionalFormat,var_Items;
int h;
;
super();
var_ConditionalFormat = COM::createFromObject(exlist1.ConditionalFormats()).Add("type(%0) = 8"); com_ConditionalFormat = var_ConditionalFormat;
com_ConditionalFormat.ForeColor(WinApi::RGB2int(255,0,0));
exlist1.Columns().Add("");
var_Items = exlist1.Items(); com_Items = var_Items;
h = com_Items.Add("Item 1");
com_Items.Add("Item 2");
com_Items.Add(COMVariant::createFromInt(2));
com_Items.Add("Item 4 - child");
}
|
|
314
|
How can I bold the items that contains data or those who displays empty strings
public void init()
{
COM com_ConditionalFormat,com_Items;
anytype var_ConditionalFormat,var_Items;
int h,hC;
;
super();
var_ConditionalFormat = COM::createFromObject(exlist1.ConditionalFormats()).Add("not len(%1)=0"); com_ConditionalFormat = var_ConditionalFormat;
com_ConditionalFormat.Bold(true);
exlist1.Columns().Add("C1");
exlist1.Columns().Add("C2");
var_Items = exlist1.Items(); com_Items = var_Items;
h = com_Items.Add("Item 1");
com_Items.Add("Item 2");
hC = com_Items.Add("Item 3");
com_Items.Caption(hC,COMVariant::createFromInt(1),"1");
com_Items.Add("Item 3");
}
|
|
313
|
Can I change the background color for items or cells that contains a specified string
public void init()
{
COM com_ConditionalFormat,com_Items;
anytype var_ConditionalFormat,var_Items;
;
super();
var_ConditionalFormat = COM::createFromObject(exlist1.ConditionalFormats()).Add("%0 contains 'hi'"); com_ConditionalFormat = var_ConditionalFormat;
com_ConditionalFormat.BackColor(WinApi::RGB2int(255,0,0));
exlist1.Columns().Add("");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add("Item 1");
com_Items.Add("Item 2");
com_Items.Add("Item 3");
com_Items.Add("Item 4 - child");
}
|
|
312
|
Is there any option to change the fore color for cells or items that ends with a specified string
public void init()
{
COM com_ConditionalFormat,com_Items;
anytype var_ConditionalFormat,var_Items;
;
super();
var_ConditionalFormat = COM::createFromObject(exlist1.ConditionalFormats()).Add("%0 endwith '22'"); com_ConditionalFormat = var_ConditionalFormat;
com_ConditionalFormat.ForeColor(WinApi::RGB2int(255,0,0));
exlist1.Columns().Add("");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add("Item 1");
com_Items.Add("Item 2");
com_Items.Add("Item 1.22");
com_Items.Add("Item 2.22");
}
|
|
311
|
How can I highlight the cells or items that starts with a specified string
public void init()
{
COM com_ConditionalFormat,com_Items;
anytype var_ConditionalFormat,var_Items;
;
super();
var_ConditionalFormat = COM::createFromObject(exlist1.ConditionalFormats()).Add("%0 startwith 'C'"); com_ConditionalFormat = var_ConditionalFormat;
com_ConditionalFormat.Underline(true);
exlist1.Columns().Add("");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add("Item 1");
com_Items.Add("CItem 2");
com_Items.Add("Item 3");
com_Items.Add("Item 4");
}
|
|
310
|
How can I change the foreground color for a particular column
public void init()
{
COM com_Columns;
anytype var_Columns;
;
super();
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
com_Columns.Add("Column 1");
COM::createFromVariant(com_Columns.Add("Column 2")).Def(8/*exHeaderForeColor*/,COMVariant::createFromInt(8439039));
com_Columns.Add("Column 3");
}
|
|
309
|
How can I change the background color for a particular column
public void init()
{
COM com_Columns;
anytype var_Columns;
;
super();
var_Columns = exlist1.Columns(); com_Columns = var_Columns;
com_Columns.Add("Column 1");
COM::createFromVariant(com_Columns.Add("Column 2")).Def(7/*exHeaderBackColor*/,COMVariant::createFromInt(8439039));
com_Columns.Add("Column 3");
}
|
|
308
|
How can I display the column's header using multiple lines
public void init()
{
;
super();
exlist1.HeaderHeight(128);
exlist1.HeaderSingleLine(false);
COM::createFromVariant(exlist1.Columns().Add("This is just a column that should break the header.")).Width(32);
exlist1.Columns().Add("This is just another column that should break the header.");
}
|
|
307
|
How can I align the text/caption on the scroll bar
public void init()
{
;
super();
exlist1.ScrollPartCaption(1/*exHScroll*/,512/*exLowerBackPart*/,"left");
exlist1.ScrollPartCaptionAlignment(1/*exHScroll*/,512/*exLowerBackPart*/,0/*LeftAlignment*/);
exlist1.ScrollPartCaption(1/*exHScroll*/,128/*exUpperBackPart*/,"right");
exlist1.ScrollPartCaptionAlignment(1/*exHScroll*/,128/*exUpperBackPart*/,2/*RightAlignment*/);
exlist1.ColumnAutoResize(false);
exlist1.Columns().Add(1);
exlist1.Columns().Add(2);
exlist1.Columns().Add(3);
exlist1.Columns().Add(4);
exlist1.Columns().Add(5);
exlist1.Columns().Add(6);
}
|
|
306
|
How do I select the next row/item
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.Columns().Add("Column");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add("Item 1");
com_Items.Add("Item 2");
com_Items.Add("Item 3");
com_Items.SelectItem(com_Items.NextVisibleItem(com_Items.FocusItem()),true);
}
|
|
305
|
How do I enable resizing ( changing the height ) the items at runtime
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.ItemsAllowSizing(-1/*exResizeItem*/);
exlist1.DrawGridLines(1/*exHLines*/);
exlist1.ScrollBySingleLine(true);
exlist1.Columns().Add("Column");
exlist1.Items().Add("Item 1");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.ItemHeight(com_Items.Add("Item 2"),48);
exlist1.Items().Add("Item 3");
exlist1.Items().Add("Item 4");
}
|
|
304
|
How do I enable resizing all the items at runtime
public void init()
{
COM com_Items;
anytype var_Items;
;
super();
exlist1.ItemsAllowSizing(1/*exResizeAllItems*/);
exlist1.DrawGridLines(1/*exHLines*/);
exlist1.Columns().Add("Column");
exlist1.Items().Add("Item 1");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.ItemHeight(com_Items.Add("Item 2"),48);
exlist1.Items().Add("Item 3");
}
|
|
303
|
How can I remove the filter
public void init()
{
COM com_Column;
anytype var_Column;
;
super();
var_Column = COM::createFromVariant(exlist1.Columns().Add("Column")); com_Column = var_Column;
com_Column.DisplayFilterButton(true);
com_Column.FilterType(1/*exBlanks*/);
exlist1.ApplyFilter();
exlist1.ClearFilter();
}
|
|
302
|
How do I change the control's border, using your EBN files
public void init()
{
;
super();
exlist1.VisualAppearance().Add(1,"c:\\exontrol\\images\\normal.ebn");
exlist1.Appearance(16777216);
}
|
|
301
|
Can I change the style for break or divider line
public void init()
{
COM com_Items;
anytype var_Items;
int h;
;
super();
exlist1.Columns().Add("Default");
var_Items = exlist1.Items(); com_Items = var_Items;
com_Items.Add("Item 1");
h = com_Items.Add();
com_Items.ItemBreak(h,2/*DoubleLine*/);
com_Items.SelectableItem(h,false);
com_Items.Add("Item 3");
}
|